import java.io.*;
import java.net.*;
import java.sql.*;
public class Target extends Thread { //implements Runnable {
	   Socket socket;
	      DataOutputStream out=null;
	         DataInputStream  in=null;
		    PreparedStatement sqlOne,sqlTwo;
		       boolean boo=false;
		          Target(Socket t, PreparedStatement sqlOne,PreparedStatement sqlTwo) {
				        socket=t;
					      this.sqlOne=sqlOne;
					            this.sqlTwo=sqlTwo;  
						          try {  out=new DataOutputStream(socket.getOutputStream());
								               in=new DataInputStream(socket.getInputStream());
									             }
							        catch(IOException e){
									          System.out.println(e);
										        }
								   }  
			     public void run() {
				           ResultSet rs = null; 
					         while(true) {
							         try{
									             String str=in.readUTF();
										                 if(str.startsWith("number:")) {
													                str = str.substring(str.indexOf(":")+1);
															               sqlOne.setString(1,str);
																                      rs=sqlOne.executeQuery();
																		                  }
												             else if(str.startsWith("name")) {
														                    str = str.substring(str.indexOf(":")+1);
																                   sqlTwo.setString(1,str);
																		                  rs=sqlTwo.executeQuery();
																				              }
													                 while(rs.next()) {
																                boo=true;
																		               String number=rs.getString(1);
																			                      String name=rs.getString(2);
																					                     Date time=rs.getDate(3);
																							                    float height=rs.getFloat(4);
																									                   out.writeUTF("学号:"+number+"姓名:"+name+"出生日期:"+ time+ 
																													   	               "身高:"+height); 
																											               }
															             if(boo==false)
																	                    out.writeUTF("没该学号！");
																            }
								        catch (IOException e) { 
										           System.out.println("客户离开"+e);
											                  return;
													         }
									       catch (SQLException e) { 
										                  System.out.println(e);
												         }
									            }
						    } 
}
